-
Re: FORMULA TO PRESENT THE MONTH (NAME) IN A CELL
If you only need three digit month names the formula is much simpler: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)7 · -
Re: FORMULA TO PRESENT THE MONTH (NAME) IN A CELL
If you only need three digit month names the formula is much simpler: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)1 · -
Re: HUGE ISSUE WITH SMARTSHEET INTAKE FORMS!
Fields that are hidden by logic do not become mandatory until they are made visible. Interestingly, if you reverse the data entry that made them visible (and they become invisible again) they will re…1 · -
Re: How can I get the month text
For three digit month names you can avoid nasty nested IFs by using a much simpler formula: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)4 ·